-- @owner: li-xin12345
-- @date: 2024-08-07
-- @testpoint: 删除存储过程（authid current_user）

--step1:创建表t_Objects_0138;expect:成功
drop table if exists t_Objects_0138 cascade;
create table t_Objects_0138(a integer) with (storage_type=ustore);

--step2:创建一个存储过程，包含authid current_user(表明该函数将带着调用它的用户的权限执行)参数;expect:成功
drop procedure if exists insert_data;
create or replace procedure insert_data(v integer)    
authid current_user
as
begin
    insert into t_Objects_0138 values(v);
end;
/

--step3:调用此存储过程;expect:成功
call insert_data(1);

--step4:查看表t_Objects_0138内数据;expect:成功
select * from t_Objects_0138;

--step5:清理环境;expect:成功
drop procedure if exists insert_data;
drop table if exists t_Objects_0138 cascade;